💁Agenda of the Video▶️: To share the Online Query's Answer. <br />🔰Question: How can I get a Report of List of Items which are differentiated by Consumable or Inventory? <br />📝Answer : Inventory Valuation Report. This is an inbuilt / standard report (and the... Report id is, 1001). <br />✅ GRN / Shipment (Received Not Invoiced / Shipped Not Invoiced)= Expected or Estimated Cost of Inventory. <br />➡️Related to Item Ledger Entries (in short; ILE, table). <br />✅ Invoice = Actual Values or Inventory Cost Posting to G/L (associated General Ledger of Items/Inventory/Stock). <br />➡️Related to Value Entries (table). <br />🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸 <br />📍Hint: Closing Stock = Opening Stock / Inputs / GRN + Purchase (increase in the Year) + Positive Adjustment [Less (-) Dispatch + Sales (Decrease in the Year) + Negative Adjustment]. ✅ <br />🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸
